Devin Lee ✭✭✭✭✭

Overview

Overview

Email	devinleedesign@gmail.com
Roles	Member
Badges	17

About Me

About Me

Area of Expertise	Project Management
About Me	Merging Design and Construction
How I Use Smartsheet	Help manage 45 projects per year
Linkedin	https://www.linkedin.com/in/devinclee/

Analytics

181

Posts

205

Visits

644

Points

Nov 19, 2021

Join Date

Oct 18, 2024

Last Active

Reactions

• Insightful 9

  9
• Vote Up 23

  23
• Awesome 22

  22

• Activity
• Discussions
• Comments181

• Re: Create Month Over Month Reporting

  Devin Lee

  06/04/24
  You may need to convert these to sheet reference ranges but here is a general formula you can use. The idea being you can set the start and end to your range and it will pull the total for everything…
  1 ·

• Re: Formula to check a box if the date in another column is the current month

  Devin Lee

  06/03/24
  It's only checking the month. You will want to check both month and year. =IF(AND(MONTH(Created@row) = MONTH(TODAY()), YEAR(Created@row) = YEAR(TODAY())), 1, 0) =IF(AND(MONTH(Created@row) = MONTH(TOD…
  2 ·

• Re: Can I over ride a column formula for some row?

  Devin Lee

  03/02/23
  @Lynn Ballas "=1" is checking to see if the check box is checked. Checked = 1 Unchecked = 0
  1 ·

• Re: Counting blank cells when other criteria is met

  Devin Lee

  02/16/23
  =COUNTIFS(Status:Status, OR(@cell = "In Progress", @cell = "Not Started"), [Target Completion Date]:[Target Completion Date], <TODAY()) + COUNTIFS(Status:Status, OR(@cell = &qu…
  1 ·

• Re: sequential taske formula...Stuck PLS help

  Devin Lee

  01/30/23
  Here is a formula for that =IF(AND([Task1]@row = 0, [Task2]@row = 0, [Task3]@row = 0, [Task4]@row = 0, [Task5]@row = 0), 0, IF(AND([Task1]@row <> 0, [Task2]@row = 0, [Task3]@row = 0, [Task4]@ro…
  1 ·

Next